﻿--获取员工档案
CREATE proc [dbo].[proc_Employee_GetList]
as

	select 
		 id
		,UserName
		,EName
		,Enumber
		,ETempNumber
		,Sex
		,CompanyId
		,(select companyname from company where id=CompanyId) as CompanyName
		,DepartmentId
		,(select dname from Department where id=DepartmentId) as DepartmentName
		,State
		,RuzhiDate
		,LizhiDate
		,Birthday
		,Rtx
		,OfficePhone
		,HomePhone
		,MobilePhone
		,Email
		,IDcard
		,Address
		,Education
		,HeadPic
		,UpName
		,UpTime
	from employee